Tabela Episode

Definicja tabeli Episode

Name

Episode

Code

Episode

Comment

PL: Informacje o jednostkowym zdarzeniu(wskazanie skierowania, pacjenta, itp.)
EN: Episode information (point at referral and patient)


Lista kolumn tabeli Episode

Name

Code

EpisodeID

EpisodeID

EpisodeTypeID

EpisodeTypeID

DischargeModeID

DischargeModeID

DischargeDirectionID

DischargeDirectionID

EpisodeStatID

EpisodeStatID

AdmissionModeID

AdmissionModeID

ReferralID

ReferralID

EpisodeKindID

EpisodeKindID

HospitalID

HospitalID

PersonID

PersonID

HospitalizationTypeID

HospitalizationTypeID

HospitalizationModeID

HospitalizationModeID

WardAdmissionEventID

WardAdmissionEventID

StartDT

StartDT

StopDT

StopDT

Comments

Comments

DischargedTo

DischargedTo

ExpectedStopDT

ExpectedStopDT

CancelReason

CancelReason

CauseOfDeath

CauseOfDeath

ToSend

ToSend

Character

Character

HospitalizationMode

HospitalizationMode

AdmissionRefuse

AdmissionRefuse

ReceivedByCurator

ReceivedByCurator

isEmergency

isEmergency

isNFZ

isNFZ

InsertingPerson

InsertingPerson

InsertDate

InsertDate

LastModifiedPerson

LastModifiedPerson

LastModifiedDT

LastModifiedDT

EpisodePriorityID

EpisodePriorityID

NextHospitalizationICDID

NextHospitalizationICDID

SuggestedSanatoriumID

SuggestedSanatoriumID

AgreedWithPersonID

AgreedWithPersonID

DischargingPersonID

DischargingPersonID

StatisticalComment

StatisticalComment

ContactedInfectious

ContactedInfectious

NextHospitalizationDate

NextHospitalizationDate


Kolumna EpisodeID tabeli Episode

Definicja kolumny EpisodeID tabeli Episode

Name

EpisodeID

Code

EpisodeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID epizodu


Kolumna EpisodeTypeID tabeli Episode

Definicja kolumny EpisodeTypeID tabeli Episode

Name

EpisodeTypeID

Code

EpisodeTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna DischargeModeID tabeli Episode

Definicja kolumny DischargeModeID tabeli Episode

Name

DischargeModeID

Code

DischargeModeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DischargeDirectionID tabeli Episode

Definicja kolumny DischargeDirectionID tabeli Episode

Name

DischargeDirectionID

Code

DischargeDirectionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EpisodeStatID tabeli Episode

Definicja kolumny EpisodeStatID tabeli Episode

Name

EpisodeStatID

Code

EpisodeStatID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna AdmissionModeID tabeli Episode

Definicja kolumny AdmissionModeID tabeli Episode

Name

AdmissionModeID

Code

AdmissionModeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ReferralID tabeli Episode

Definicja kolumny ReferralID tabeli Episode

Name

ReferralID

Code

ReferralID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EpisodeKindID tabeli Episode

Definicja kolumny EpisodeKindID tabeli Episode

Name

EpisodeKindID

Code

EpisodeKindID

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna HospitalID tabeli Episode

Definicja kolumny HospitalID tabeli Episode

Name

HospitalID

Code

HospitalID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonID tabeli Episode

Definicja kolumny PersonID tabeli Episode

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna HospitalizationTypeID tabeli Episode

Definicja kolumny HospitalizationTypeID tabeli Episode

Name

HospitalizationTypeID

Code

HospitalizationTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna HospitalizationModeID tabeli Episode

Definicja kolumny HospitalizationModeID tabeli Episode

Name

HospitalizationModeID

Code

HospitalizationModeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna WardAdmissionEventID tabeli Episode

Definicja kolumny WardAdmissionEventID tabeli Episode

Name

WardAdmissionEventID

Code

WardAdmissionEventID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID pierwszego eventa oddzialowego w calym Epizodzie


Kolumna StartDT tabeli Episode

Definicja kolumny StartDT tabeli Episode

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli Episode

Definicja kolumny StopDT tabeli Episode

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Comments tabeli Episode

Definicja kolumny Comments tabeli Episode

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna DischargedTo tabeli Episode

Definicja kolumny DischargedTo tabeli Episode

Name

DischargedTo

Code

DischargedTo

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ExpectedStopDT tabeli Episode

Definicja kolumny ExpectedStopDT tabeli Episode

Name

ExpectedStopDT

Code

ExpectedStopDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna CancelReason tabeli Episode

Definicja kolumny CancelReason tabeli Episode

Name

CancelReason

Code

CancelReason

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna CauseOfDeath tabeli Episode

Definicja kolumny CauseOfDeath tabeli Episode

Name

CauseOfDeath

Code

CauseOfDeath

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna ToSend tabeli Episode

Definicja kolumny ToSend tabeli Episode

Name

ToSend

Code

ToSend

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna Character tabeli Episode

Definicja kolumny Character tabeli Episode

Name

Character

Code

Character

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna HospitalizationMode tabeli Episode

Definicja kolumny HospitalizationMode tabeli Episode

Name

HospitalizationMode

Code

HospitalizationMode

Data Type

VARCHAR2(5)

Mandatory

No

Comment

 


Kolumna AdmissionRefuse tabeli Episode

Definicja kolumny AdmissionRefuse tabeli Episode

Name

AdmissionRefuse

Code

AdmissionRefuse

Data Type

NUMBER(10)

Mandatory

No

Comment

Odmowa przyjecia do
szpitala na wlasne zyczenie


Kolumna ReceivedByCurator tabeli Episode

Definicja kolumny ReceivedByCurator tabeli Episode

Name

ReceivedByCurator

Code

ReceivedByCurator

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna isEmergency tabeli Episode

Definicja kolumny isEmergency tabeli Episode

Name

isEmergency

Code

isEmergency

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna isNFZ tabeli Episode

Definicja kolumny isNFZ tabeli Episode

Name

isNFZ

Code

isNFZ

Data Type

NUMBER(3)

Mandatory

No

Comment

Informacja, ze za dane zamówienie placi NFZ


Kolumna InsertingPerson tabeli Episode

Definicja kolumny InsertingPerson tabeli Episode

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

Osoba tworzaca rekord


Kolumna InsertDate tabeli Episode

Definicja kolumny InsertDate tabeli Episode

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

No

Comment

Data utworzenia rekordu


Kolumna LastModifiedPerson tabeli Episode

Definicja kolumny LastModifiedPerson tabeli Episode

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

Ostatnio modyfikujaca osoba


Kolumna LastModifiedDT tabeli Episode

Definicja kolumny LastModifiedDT tabeli Episode

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Kolumna EpisodePriorityID tabeli Episode

Definicja kolumny EpisodePriorityID tabeli Episode

Name

EpisodePriorityID

Code

EpisodePriorityID

Data Type

NUMBER(10)

Mandatory

No

Comment

priorytet hospitalizacji


Kolumna NextHospitalizationICDID tabeli Episode

Definicja kolumny NextHospitalizationICDID tabeli Episode

Name

NextHospitalizationICDID

Code

NextHospitalizationICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

[RU / ekran wypisu] Diagnoza kolejnej hospitalizacji


Kolumna SuggestedSanatoriumID tabeli Episode

Definicja kolumny SuggestedSanatoriumID tabeli Episode

Name

SuggestedSanatoriumID

Code

SuggestedSanatoriumID

Data Type

NUMBER(10)

Mandatory

No

Comment

[RU / ekran wypisu] Rekomendowane leczenie w sanatorium


Kolumna AgreedWithPersonID tabeli Episode

Definicja kolumny AgreedWithPersonID tabeli Episode

Name

AgreedWithPersonID

Code

AgreedWithPersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DischargingPersonID tabeli Episode

Definicja kolumny DischargingPersonID tabeli Episode

Name

DischargingPersonID

Code

DischargingPersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID pacjenta


Kolumna StatisticalComment tabeli Episode

Definicja kolumny StatisticalComment tabeli Episode

Name

StatisticalComment

Code

StatisticalComment

Data Type

VARCHAR2(512)

Mandatory

No

Comment

komentarz statystyczny


Kolumna ContactedInfectious tabeli Episode

Definicja kolumny ContactedInfectious tabeli Episode

Name

ContactedInfectious

Code

ContactedInfectious

Data Type

VARCHAR2(64)

Mandatory

No

Comment

[RU / ekran wypisu] Kontakt z zakazonym pacjentem


Kolumna NextHospitalizationDate tabeli Episode

Definicja kolumny NextHospitalizationDate tabeli Episode

Name

NextHospitalizationDate

Code

NextHospitalizationDate

Data Type

DATE

Mandatory

No

Comment

[RU / ekran wypisu] Data kolejnej hospitalizacji


Lista kluczy tabeli Episode

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Episode

Definicja klucza Identifier_1 tabeli Episode

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment